String Functions – SUBSTRING()

I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the SUBSTRING() function today. The SUBSTRING() function allows a developer to slice and dice a string into pieces. It takes a source string [T], a integer starting position [S], and a the number of characters [C] to return as input parameters. It returns a string of [C] characters from position [S] as output. The example below extracts one word from a famous movie title. [crayon-664966369f536947448462/] [crayon-664966369f53f335810951/] One thing to … Continue reading String Functions – SUBSTRING()